Determining Third Party Volume by Manufacturer

The following procedure explains how to determine your Third Party prescription volume for a specific manufacturer. Ontario pharmacies can use this procedure to obtain the volume of ODB vs non-ODB prescriptions for a manufacturer.

Part 1. Create a Drug Movement report for the manufacturer

This report provides overall prescription and dollar volume for the manufacturer.

  1. Open Propel Rx Reports.

  2. Select Drug Movement.

  3. Select Next.

  4. Enter the report period in the Start Date and End Date fields.

  5. In the Manufacturer field, enter the manufacturer's 3-letter code (i.e., APX for Apotex).

  6. Optional: Select Preview.

  7. Select Print.

Your total prescription volume for the manufacturer is the Number of Rx's Dispensed in the Gross Profit Totals on the last page of the report. Total Dollar Volume is the dollar value of all prescriptions filled for the manufacturer. Number of Drugs Dispensed indicates how many of this manufacturer's drugs have been used in prescriptions.

Part 2. Create a Drug Movement report for the Third Party's prescriptions for the manufacturer

This report provides prescription and dollar volume for a Third Party's prescriptions that were filled using the manufacturer's products.

  1. If you are in the Preview window, select Previous to return to the Criteria tab.

  2. Ensure the Start Date and End Date are the same.

  3. Enter the Third Party's name in the Third Party field (i.e., Drug Benefit).

  4. In the Manufacturer field, enter the manufacturer's 3-letter code (i.e., APX for Apotex).

  5. Optional: Select Preview.

  6. Select Print.

Your Third Party's prescription volume of the manufacturer is the Number of Rx's Dispensed in the Gross Profit Totals on the last page of the report. The Number of Drugs Dispensed and Total Dollar Volume reflect the number of the manufacturer's drugs used for the Third Party's prescriptions and the dollar value of all these prescriptions, respectively.

Part 3. Calculate the totals

To determine the non-Third Party volume for the manufacturer, subtract the prescription volume from the second report (the Third Party report) from the Number of Rx's Dispensed on the first report (the manufacturer's report).

TP Volume % = (TP Prescription Volume from the TP Report/Number of Rx's Dispensed for the Manufacturer) x 100%

Non-TP Volume % = 100 - TP Volume %